/*
@biz_management.sql

*/

--CREATE OR REPLACE PACKAGE biz_management AS
CREATE PACKAGE biz_management AS

FUNCTION get_customer_seq
RETURN NUMBER;

FUNCTION get_next_userid
RETURN NUMBER;

END biz_management;
/

--CREATE OR REPLACE PACKAGE BODY biz_management AS
CREATE PACKAGE BODY biz_management AS

FUNCTION get_customer_seq
RETURN NUMBER IS
  next_val NUMBER;
BEGIN
  SELECT seq_global.NEXTVAL
     INTO next_val
     FROM DUAL;
  RETURN(next_val);
END;

FUNCTION get_next_userid
RETURN NUMBER IS
  next_val NUMBER;
BEGIN
  SELECT seq_customer_userid.NEXTVAL
     INTO next_val
     FROM DUAL;
  RETURN(next_val);
END;

END biz_management;
/


